SELECT col7 , col0 , LAST_VALUE(col0) OVER(PARTITION BY col7 ORDER BY col0 ) LAST_VALUE_col0 FROM "allTypsUniq.parquet" WHERE col0 >= 0 AND col0 <= 2147483647